Implementing Campaign Manager - Pentaho Data Integration (Kettle)


Injecting a custom transformation into an Output Tactic

Description of how to test, and then create, a simple Kettle job that can be called as part of a Campaign Manager campaign.

Testing a Kettle transformation job

The best way to test a Kettle transformation job is to:

  • run a campaign tactic in Campaign Manager to create an output file
  • copy the file to test
  • run the Kettle transformation job against it independently, that is, not integrated

Once the transformation has been signed off, it would then be configured using the Campaign Manager Admin tool. You can find detailed instructions in the Campaign Manager Administration Guide.

File Tactic

For the existing FTP File Tactic, the data flow involves the file being initially written to the FTPOutputStagingDirectory, as defined in the deployer (stored in Web.Config file). Once complete, the finished file is transferred to the user selected FTP location, which has been pre-configured in the Campaign Manager Admin area.

The integration with Kettle simply intercepts that flow at the point where the completed file is written to the FTPOutputStagingDirectory. Campaign Manager triggers the configured Pentaho Kettle Job against the file in that staging folder. Once the Pentaho Kettle job is complete, Campaign Manager will then proceed with copying the file from the FTPOutputStagingDirectory to the ftp site as before. The file name will persist throughout.

Omni Tactic

For the integration with Omni Tactics, the data flow is different from File Tactics. In the Omni Tactic, no output locations are available to the user by default. The campaign processor uses the FTPOutputStagingDirectory, but the Job needs to define file names, output locations etc.

Key values such as Channel Type, Channel Name, and Creative Name can all be written to Campaign history for reporting purposes.

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice